“Practicing safe spreadsheeting” : a case study examination of spreadsheet use and the challenges and risks associated with their use in a private sector business operating in Halifax, Nova Scotia (Canada)

1 online resource (157 p.) : col. ill.Includes abstract and appendices.Includes bibliographical references (p. 147-156).Spreadsheets have been and continue to be one of most commonly used analytical tools by many businesses today. With the increasing pressures on businesses today associated with making sense of increasingly larger data sets, it begs the question: are they the ‘right’ tool to be used. The purpose of this case study is to examine how spreadsheets are being used and the risks associated with their (spreadsheet) use within a private sector organization operating in Halifax, Nova Scotia, using a subject group of participants comprised of various types of spreadsheet users working in different functional areas of the organization. The data were collected through a series of one-on-one interviews with each participant, using a standard list of questions developed specifically for this research study, that captured the participants’ experiences using spreadsheets within their organization. The aim of this case study is to determine the extent of use and reliance on spreadsheets by the participants and their organization, and the challenges and risks (due to potential errors) associated with their use. Additionally this case study also looks at potential techniques and tools that may be used to mitigate the risks of spreadsheet errors and the organizations reliance on spreadsheets, as well as offering an assessment of the capabilities (skill level) of the spreadsheet users/creators

Finishing the euchromatic sequence of the human genome

The sequence of the human genome encodes the genetic instructions for human physiology, as well as rich information about human evolution. In 2001, the International Human Genome Sequencing Consortium reported a draft sequence of the euchromatic portion of the human genome. Since then, the international collaboration has worked to convert this draft into a genome sequence with high accuracy and nearly complete coverage. Here, we report the result of this finishing process. The current genome sequence (Build 35) contains 2.85 billion nucleotides interrupted by only 341 gaps. It covers ∼99% of the euchromatic genome and is accurate to an error rate of ∼1 event per 100,000 bases. Many of the remaining euchromatic gaps are associated with segmental duplications and will require focused work with new methods. The near-complete sequence, the first for a vertebrate, greatly improves the precision of biological analyses of the human genome including studies of gene number, birth and death. Notably, the human enome seems to encode only 20,000-25,000 protein-coding genes. The genome sequence reported here should serve as a firm foundation for biomedical research in the decades ahead

SARS-CoV-2 Omicron is an immune escape variant with an altered cell entry pathway

Vaccines based on the spike protein of SARS-CoV-2 are a cornerstone of the public health response to COVID-19. The emergence of hypermutated, increasingly transmissible variants of concern (VOCs) threaten this strategy. Omicron (B.1.1.529), the fifth VOC to be described, harbours multiple amino acid mutations in spike, half of which lie within the receptor-binding domain. Here we demonstrate substantial evasion of neutralization by Omicron BA.1 and BA.2 variants in vitro using sera from individuals vaccinated with ChAdOx1, BNT162b2 and mRNA-1273. These data were mirrored by a substantial reduction in real-world vaccine effectiveness that was partially restored by booster vaccination. The Omicron variants BA.1 and BA.2 did not induce cell syncytia in vitro and favoured a TMPRSS2-independent endosomal entry pathway, these phenotypes mapping to distinct regions of the spike protein. Impaired cell fusion was determined by the receptor-binding domain, while endosomal entry mapped to the S2 domain. Such marked changes in antigenicity and replicative biology may underlie the rapid global spread and altered pathogenicity of the Omicron variant

Investigation of hospital discharge cases and SARS-CoV-2 introduction into Lothian care homes

Background The first epidemic wave of severe acute respiratory syndrome coronavirus-2 (SARS-CoV-2) in Scotland resulted in high case numbers and mortality in care homes. In Lothian, over one-third of care homes reported an outbreak, while there was limited testing of hospital patients discharged to care homes. Aim To investigate patients discharged from hospitals as a source of SARS-CoV-2 introduction into care homes during the first epidemic wave. Methods A clinical review was performed for all patients discharges from hospitals to care homes from 1st March 2020 to 31st May 2020. Episodes were ruled out based on coronavirus disease 2019 (COVID-19) test history, clinical assessment at discharge, whole-genome sequencing (WGS) data and an infectious period of 14 days. Clinical samples were processed for WGS, and consensus genomes generated were used for analysis using Cluster Investigation and Virus Epidemiological Tool software. Patient timelines were obtained using electronic hospital records. Findings In total, 787 patients discharged from hospitals to care homes were identified. Of these, 776 (99%) were ruled out for subsequent introduction of SARS-CoV-2 into care homes. However, for 10 episodes, the results were inconclusive as there was low genomic diversity in consensus genomes or no sequencing data were available. Only one discharge episode had a genomic, time and location link to positive cases during hospital admission, leading to 10 positive cases in their care home. Conclusion The majority of patients discharged from hospitals were ruled out for introduction of SARS-CoV-2 into care homes, highlighting the importance of screening all new admissions when faced with a novel emerging virus and no available vaccine

Students' participation in collaborative research should be recognised

Letter to the editor

COVID-19 due to the B.1.617.2 (Delta) variant compared to B.1.1.7 (Alpha) variant of SARS-CoV-2: a prospective observational cohort study

The Delta (B.1.617.2) variant was the predominant UK circulating SARS-CoV-2 strain between May and December 2021. How Delta infection compares with previous variants is unknown. This prospective observational cohort study assessed symptomatic adults participating in the app-based COVID Symptom Study who tested positive for SARS-CoV-2 from May 26 to July 1, 2021 (Delta overwhelmingly the predominant circulating UK variant), compared (1:1, age- and sex-matched) with individuals presenting from December 28, 2020 to May 6, 2021 (Alpha (B.1.1.7) the predominant variant). We assessed illness (symptoms, duration, presentation to hospital) during Alpha- and Delta-predominant timeframes; and transmission, reinfection, and vaccine effectiveness during the Delta-predominant period. 3581 individuals (aged 18 to 100 years) from each timeframe were assessed. The seven most frequent symptoms were common to both variants. Within the first 28 days of illness, some symptoms were more common with Delta versus Alpha infection (including fever, sore throat, and headache) and some vice versa (dyspnoea). Symptom burden in the first week was higher with Delta versus Alpha infection; however, the odds of any given symptom lasting ≥ 7 days was either lower or unchanged. Illness duration ≥ 28 days was lower with Delta versus Alpha infection, though unchanged in unvaccinated individuals. Hospitalisation for COVID-19 was unchanged. The Delta variant appeared more (1.49) transmissible than Alpha. Re-infections were low in all UK regions. Vaccination markedly reduced the risk of Delta infection (by 69-84%). We conclude that COVID-19 from Delta or Alpha infections is similar. The Delta variant is more transmissible than Alpha; however, current vaccines showed good efficacy against disease. This research framework can be useful for future comparisons with new emerging variants

Genomic epidemiology of SARS-CoV-2 in a university outbreak setting and implications for public health planning

AbstractWhole genome sequencing of SARS-CoV-2 has occurred at an unprecedented scale, and can be exploited for characterising outbreak risks at the fine-scale needed to inform control strategies. One setting at continued risk of COVID-19 outbreaks are higher education institutions, associated with student movements at the start of term, close living conditions within residential halls, and high social contact rates. Here we analysed SARS-CoV-2 whole genome sequences in combination with epidemiological data to investigate a large cluster of student cases associated with University of Glasgow accommodation in autumn 2020, Scotland. We identified 519 student cases of SARS-CoV-2 infection associated with this large cluster through contact tracing data, with 30% sequencing coverage for further analysis. We estimated at least 11 independent introductions of SARS-CoV-2 into the student population, with four comprising the majority of detected cases and consistent with separate outbreaks. These four outbreaks were curtailed within a week following implementation of control measures. The impact of student infections on the local community was short-term despite an underlying increase in community infections. Our study highlights the need for context-specific information in the formation of public health policy for higher educational settings.</jats:p

SARS-CoV-2 lineage dynamics in England from September to November 2021: high diversity of Delta sub-lineages and increased transmissibility of AY.4.2

Abstract Background Since the emergence of SARS-CoV-2, evolutionary pressure has driven large increases in the transmissibility of the virus. However, with increasing levels of immunity through vaccination and natural infection the evolutionary pressure will switch towards immune escape. Genomic surveillance in regions of high immunity is crucial in detecting emerging variants that can more successfully navigate the immune landscape. Methods We present phylogenetic relationships and lineage dynamics within England (a country with high levels of immunity), as inferred from a random community sample of individuals who provided a self-administered throat and nose swab for rt-PCR testing as part of the REal-time Assessment of Community Transmission-1 (REACT-1) study. During round 14 (9 September–27 September 2021) and 15 (19 October–5 November 2021) lineages were determined for 1322 positive individuals, with 27.1% of those which reported their symptom status reporting no symptoms in the previous month. Results We identified 44 unique lineages, all of which were Delta or Delta sub-lineages, and found a reduction in their mutation rate over the study period. The proportion of the Delta sub-lineage AY.4.2 was increasing, with a reproduction number 15% (95% CI 8–23%) greater than the most prevalent lineage, AY.4. Further, AY.4.2 was less associated with the most predictive COVID-19 symptoms (p = 0.029) and had a reduced mutation rate (p = 0.050). Both AY.4.2 and AY.4 were found to be geographically clustered in September but this was no longer the case by late October/early November, with only the lineage AY.6 exhibiting clustering towards the South of England. Conclusions As SARS-CoV-2 moves towards endemicity and new variants emerge, genomic data obtained from random community samples can augment routine surveillance data without the potential biases introduced due to higher sampling rates of symptomatic individuals. </jats:sec

Genomic reconstruction of the SARS-CoV-2 epidemic in England

AbstractThe evolution of the severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) virus leads to new variants that warrant timely epidemiological characterization. Here we use the dense genomic surveillance data generated by the COVID-19 Genomics UK Consortium to reconstruct the dynamics of 71 different lineages in each of 315 English local authorities between September 2020 and June 2021. This analysis reveals a series of subepidemics that peaked in early autumn 2020, followed by a jump in transmissibility of the B.1.1.7/Alpha lineage. The Alpha variant grew when other lineages declined during the second national lockdown and regionally tiered restrictions between November and December 2020. A third more stringent national lockdown suppressed the Alpha variant and eliminated nearly all other lineages in early 2021. Yet a series of variants (most of which contained the spike E484K mutation) defied these trends and persisted at moderately increasing proportions. However, by accounting for sustained introductions, we found that the transmissibility of these variants is unlikely to have exceeded the transmissibility of the Alpha variant. Finally, B.1.617.2/Delta was repeatedly introduced in England and grew rapidly in early summer 2021, constituting approximately 98% of sampled SARS-CoV-2 genomes on 26 June 2021.</jats:p